import pandas as pd
from pymysql.converters import escape_string

import pymysql
import asyncio
import jieba

# 打开数据库连接
from aiohttp import ClientSession

db_config = {
    'host': 'dc.unifound.net', # 主机
    'user': 'root',       #用户名
    'password': 'zjdx20210126',  #密码
    'port': 63307,         #端口 3306
    'database':'uni_center'   #数据库名
}
key_points_df = pd.DataFrame(columns=['datetime', 'value', 'event'])

#range_end = pd.DataFrame([{
#    'datetime': p.datetime,
#    'value': p.value,
#    'event': f'{action}结束',
#}])
#self.key_points_df = pd.concat([self.key_points_df, range_start], ignore_index=True)

async def main():
    jieba.load_userdict("C:\\Users\\Administrator\\Desktop\\联创接口\\zjdx.txt")

    xlsx_df = pd.read_excel("C:\\Users\\Administrator\\Desktop\\联创接口\\分析要求\\view_dataset_2023-08-24 15_47_15.838393(2).xls")
    jgh = xlsx_df['JGH']
    xm = xlsx_df['XM']
    kcmc = xlsx_df['KCMC']





if __name__ == '__main__':
    loop = asyncio.get_event_loop()
    loop.run_until_complete(main())
